<style type="text/css">
body {
	background-color: #000;
}
body,td,th {
	color: #FFF;
}
</style>

<?php
$con = mysql_connect("localhost","root","1234");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("northwindDB", $con);




$result = mysql_query("SELECT * FROM  nworderdetails    " );
echo '<center>' ;
  echo  '<br><h1>Orderdetails</h1><hr><br>';
  echo '<table width="200" border="1">';
  echo '<tr><td bgcolor="#999999">' . 'OrderID'. '</td>';
  echo '<td bgcolor="#999999">' . 'ProductID'. '</td>';
  echo '<td bgcolor="#999999">' . 'UnitPrice'. '</td>';
  echo '<td bgcolor="#999999">' . 'Quantity'. '</td>';
  echo '<td bgcolor="#999999">' . 'Discount'. '</td></tr>';


while($row = mysql_fetch_array($result))
  {
  echo '<tr><td bgcolor="#999999">' .  $row['OrderID'] . '</td>';
  echo '<td bgcolor="#999999">' .  $row['ProductID'] . '</td>';
  echo '<td bgcolor="#999999">' .  $row['UnitPrice'] . '</td>';
  echo '<td bgcolor="#999999">' .  $row['Quantity'] . '</td>';
  echo '<td bgcolor="#999999">' .  $row['Discount'] . '</td></tr>';

  //echo "<br />";

  }
  echo '</table>';
  echo '</center>' ;
mysql_close($con);
?>